package com.woniuxy.yogaapp.provider;

import com.woniuxy.yogaapp.dto.UidDto;
import org.apache.ibatis.jdbc.SQL;

/*
 *@author：源
 *@date:18:39:52
 *@descripion
 */
public class OrderProvider {

    public String selectOrder(UidDto uidDto){
        SQL sql = new SQL().SELECT("oid,sid,cid,money,course,coursetime,courseperiod,sname,cname").FROM("orderclass");
        if (uidDto.getCid()!=null) {
            sql.WHERE("cid='" + uidDto.getCid() + "'");
        }
        if (uidDto.getSid()!=null) {
            sql.WHERE("sid='" + uidDto.getSid() + "'");
        }



        return  sql.toString();
    }

}
